2017-06-20 - 39656 - Break Fix - Please add Average to the item master #BExQueriesforCrystalReportsAnalysisTool

Service Request

39656 - Add Average to Item Master file

Problem Summary

---

Add Average( Shipped Revenue / Shipped Qty ) to the item master as the "List Price" field.

Admin Info

---

Purpose	Display Average in Item Master file
Requested by	Michael Carducci
Issue Date	06-20-2017
Resolved by	Bharath G
Resolved Date	06-20-2017
Document Status	Complete

Detailed Problem Description

---

Add Average( Shipped Revenue / Shipped Qty ) to the item master as the "List Price" field.

Solution Analysis and Recommendations

---

1. After adding Average field the value will display.
2. If there is no data, or an error for a particular row, it is populate with a '0' value so it can still be aggregated as a measure in the SPS database.

Resolution

---

1. We have added Shipped Revenue field and Shipped Qty field in BEX query and created a formula for Average( Shipped Revenue / Shipped Qty ).
2, The Average will display in the report and if there is no data, or an error for a particular row, it is populate with a '0' value so it can still be aggregated as a measure in the SPS database.

Release Information

---

2017-06-20 - 39656 - Rel Notes - Add Average to SPS Item Master file